﻿CREATE TABLE [dbo].[Strategy] (
    [StrategyID]      INT          NOT NULL,
    [Description]     VARCHAR (50) NULL,
    [Code]            VARCHAR (10) NULL,
    [StrategyTypeID]  INT          NULL,
    [StrategyLevelID] INT          NULL,
    [VisionID]        INT          NULL,
    [Chart]           VARCHAR (50) NULL,
    [Parameters]      VARCHAR (50) NULL,
    CONSTRAINT [PK_Strategy] PRIMARY KEY CLUSTERED ([StrategyID] ASC),
    CONSTRAINT [FK_Strategy_StrategyLevel] FOREIGN KEY ([StrategyLevelID]) REFERENCES [dbo].[StrategyLevel] ([StrategyLevelID]),
    CONSTRAINT [FK_Strategy_StrategyTypeID] FOREIGN KEY ([StrategyTypeID]) REFERENCES [dbo].[StrategyType] ([StrategyTypeID]),
    CONSTRAINT [FK_Strategy_Vision] FOREIGN KEY ([VisionID]) REFERENCES [dbo].[Vision] ([VisionID])
);

